Easy2Siksha.com
• The Line Chart: Imagine drawing a line connecting mountain peaks. You use this to
show trends over time. If you want to see if your bake sale is making more money as
the month goes on, a line chart will show a line sloping upwards (hopefully!).
Once you click the little icon for the chart you want, Excel does the rest. Boom! The chart
appears right on your screen. You can click on the title to change it, drag the corners to
make it bigger, and even change the colors so it matches your school's theme.
Part B: The Power of the Pivot Table (The Data Shapeshifter)
Charts are amazing, but there is a catch: to make a basic chart, your data already needs to
be somewhat organized and summarized.
But what if we go back to our original problem? You don't have a neat little summary table;
you have 500 messy rows of every single transaction that happened all month. If you try to
make a pie chart out of 500 rows, it will look like a colorful explosion.
You need to organize the data first. You could grab a calculator and manually add up every
single brownie Sarah sold, but that would take hours. Instead, we use a Pivot Table.
A Pivot Table is like a magical sorting hat for your data. It is a feature that takes a giant,
messy list of data and instantly summarizes it for you, without you ever having to type a
single math formula. It is called a "pivot" table because you can twist and turn (pivot) the
data to look at it from different angles.
How to Use a Pivot Table to Analyze Data:
To create one, you click anywhere inside your giant block of data, go to that same Insert tab
at the top, and click the big button on the far left that says PivotTable. Excel will open a
fresh, blank canvas for you.
On the right side of your screen, a control panel will appear. This is called the PivotTable
Fields list. It lists all the column titles from your messy data (Date, Student, Item, Price).
Below that list are four empty boxes: Filters, Columns, Rows, and Values.
This is where the magic happens. You analyze data simply by dragging and dropping words
into these boxes!
• The Rows Box: Let's drag the word "Student" into the Rows box. Instantly, on the
left side of your screen, Excel looks through all 500 rows, ignores all the duplicates,
and gives you a neat, alphabetical list of your sellers: Emily, John, Sarah.
• The Values Box (The Calculator): Now, you want to know how much money they
made. Drag the word "Price" into the Values box. Excel instantly adds up every single
sale John made, every sale Sarah made, and puts the total right next to their names.
In two seconds, you did what would have taken an hour with a calculator.
• The Columns Box (The Deep Dive): Let's get fancier. What if you want to know what
they sold? Drag the word "Item" into the Columns box. Suddenly, your simple list